package cn.gson.crm.model.mapper;

import cn.gson.crm.model.pojos.*;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface InvoiceMapper {
    //查询当前人发货单
    public List<Invoice> selectfahuo(Integer yid);
    public List<Invoice> selectfahuocustm(Integer cid);
    //条件查询发货单
    public List<Invoice> selectwhere(@Param("yid") Integer yid,@Param("where") String where);
    //时间查询发货单
    public List<Invoice> selecttime(@Param("yid")Integer yid,@Param("statr") String statr,@Param("endtime") String endtime);
    //查询已审批但未发货的订单
    public List<Order> selectorder();
    //查询状态未交付的交付计划
    public List<DeliveryPlan> selectDelivery(Integer oid);
    //根据交付计划查询客户信息
    public List<Customer> selectcusetomer(Integer cid);
    //根据客户查询联系人
    public List<Linkman> selectlink(Integer cid);
    public List<Employee>selectem(Integer yid);
    public void updatejiao(String pid);
    //修改发货单为已发货
    public void updatefah(Integer lid);
    //修改发货退否状态
    public void updatefahuo(@Param("tf") String tf,@Param("lid") Integer lid);
}
